UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xMmXcKQ90ngjKU+cvrsB55P2ccN1WBlEmE4phVQf9+g='
WHERE
key_id = 'c2e5b8223a0f2e7f86a933b3d8976444aa4d2ddcb395410ef3cee893e0aa0a41'
AND (
token = 'xMmXcKQ90ngjKU+cvrsB55P2ccN1WBlEmE4phVQf9+g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)