UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'X5QhygfskPWKTyWYWrS+20dfw4SdjfY6T7gktig35Lc='
WHERE
key_id = 'be94271f746e70bc1b6d7290bc2f6710ee96d379a3d97a68b5e0fd1a3a7a2229'
AND (
token = 'X5QhygfskPWKTyWYWrS+20dfw4SdjfY6T7gktig35Lc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)