UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YIyIB5h4NFm/9hhAyTNI0drgnh5/d50rDpoVvKHb3L4='
WHERE
key_id = 'b928d5b1b574e60970b7b11f5cab559524e0d00aefb60f122ed690bf474f1d9e'
AND (
token = 'YIyIB5h4NFm/9hhAyTNI0drgnh5/d50rDpoVvKHb3L4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)