UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'RXP7gtaiKZVDrHlOhMxJA9am+bl+VbEXIJPT+9bsWY8='
WHERE
key_id = 'dfb69c5f759e33791283218a946bad28367057e347bd7fe762d39d421cbafdd3'
AND (
token = 'RXP7gtaiKZVDrHlOhMxJA9am+bl+VbEXIJPT+9bsWY8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)