UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/Q/+4311ku4C8iyhHcgipoyVDZC2zhbKGLe6nv+/HQs='
WHERE
key_id = 'a55e194a2326a91cdc5bd446e891609705857fae9ab391b33bf6c79294971b18'
AND (
token = '/Q/+4311ku4C8iyhHcgipoyVDZC2zhbKGLe6nv+/HQs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)