UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'jscpi84QsfbsyIbI8nXr6OLztG69ve6utU+5m7k6He8='
WHERE
key_id = 'f53ad8694f13c4f24c2a90ffdfcb1a078557747d6cf82a85b593b938f3959a80'
AND (
token = 'jscpi84QsfbsyIbI8nXr6OLztG69ve6utU+5m7k6He8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)