UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'jz3eP3A8KYey74A6aNPQPsR74K23YfszvxQhNGjikAA='
WHERE
key_id = '7ef5f630616133be34baed4c3f96cfda8aadc329f36cfb6e84aa0bb7124585f8'
AND (
token = 'jz3eP3A8KYey74A6aNPQPsR74K23YfszvxQhNGjikAA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)