UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'DGRLwZg9Ij1YNHzDHGG13hIi5Kt2sQyQ8S5Hv/cbX8A='
WHERE
key_id = 'b4d368f045c1a65ad7ae96db7d2e9fd4bccf6663615c7c0849f2fd141c68a0a2'
AND (
token = 'DGRLwZg9Ij1YNHzDHGG13hIi5Kt2sQyQ8S5Hv/cbX8A='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)