UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pXJqIZpkjAeoPAJ3nxP+y3bWOf1SDYkFpfckJKpOYM0='
WHERE
key_id = 'b3c460524e3b0ffcae40cd91acd9902f7e31744162a4667c1179cb722ee73f0e'
AND (
token = 'pXJqIZpkjAeoPAJ3nxP+y3bWOf1SDYkFpfckJKpOYM0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)