UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0WKbqLvp9UgPK12yf36BcafrjljPpVjkXLmdM7yVClw='
WHERE
key_id = '86cc0742018daf59102cd88ad424de605e0e8a9061ad8ab4daf1349731d9af4f'
AND (
token = '0WKbqLvp9UgPK12yf36BcafrjljPpVjkXLmdM7yVClw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)