UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gEsFvYhyZ1XPNRAdNv6m9oFQcRB7rwok3Ny5y9yvxE4='
WHERE
key_id = 'd2ac8c56a00799b4a4e0e1d02867a7c43d3a5c2514ea0da6edbcc8a89e30ab03'
AND (
token = 'gEsFvYhyZ1XPNRAdNv6m9oFQcRB7rwok3Ny5y9yvxE4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)