UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YmcE4g1r1hx1ej59jWOVaMiSELFE9d7Lc7lVaXa9btw='
WHERE
key_id = '4ac63e87dda67532e0bf9f73eb78d579354cf7ee7e24a31b6d38543211cd0421'
AND (
token = 'YmcE4g1r1hx1ej59jWOVaMiSELFE9d7Lc7lVaXa9btw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)