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