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