UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hLbrgV0r0uInT4IAmvFlVSmtyWltUYRGPcu+p1n1m4o='
WHERE
key_id = '818cabaab183c160eab26b65cf0c88a15b5b348f632efe07158d8a314a227ed7'
AND (
token = 'hLbrgV0r0uInT4IAmvFlVSmtyWltUYRGPcu+p1n1m4o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)