UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pEcM2njnEIe0yD+mB4tmjwYLrvk+fEdRnPWdTMe3B5c='
WHERE
key_id = 'ca356daeda23608f3be7c48483137b37c06970008d746220a1fa398e0b766da9'
AND (
token = 'pEcM2njnEIe0yD+mB4tmjwYLrvk+fEdRnPWdTMe3B5c='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)