UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0xM1AZHvZcIPEM8n2bGlm0ASbNo+2a+bogW5Zv6m9F8='
WHERE
key_id = '4af58b39d95143d161176d28b1f7d7e81dcafa873d0c366d6ccbd2f3f88c5db2'
AND (
token = '0xM1AZHvZcIPEM8n2bGlm0ASbNo+2a+bogW5Zv6m9F8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)