UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CWhwWP64QsoUYILhXNnxkFDmR4JCo5mEAody/4kbxYQ='
WHERE
key_id = '077191797967a4b9f62532a5966254744aac5277657742abcbe74ad6c0428802'
AND (
token = 'CWhwWP64QsoUYILhXNnxkFDmR4JCo5mEAody/4kbxYQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)