UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ly/MmY2U2meiikRthPJSEEXsVN6DznWSFayO4NpQd4w='
WHERE
key_id = 'c29b894023809f10e3832cd781398bef7a7b2f8f09983f209344c2cd8bdc5db1'
AND (
token = 'ly/MmY2U2meiikRthPJSEEXsVN6DznWSFayO4NpQd4w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)