UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6ZHH5TSzR3ZXLRzprJLi98r7M2t5+2BO/rEmWAfigCA='
WHERE
key_id = '4144508484df96ca21754b2f02abacff9e9a293d2992c9e540e61499793f1a06'
AND (
token = '6ZHH5TSzR3ZXLRzprJLi98r7M2t5+2BO/rEmWAfigCA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)