UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nZbSdGqUrnO+pdnrEsRtYCzU54Fc9jXntNYN2N4uaHE='
WHERE
key_id = 'c1c586fb70fa48b9ec686c3d4345466b08dbd52943040d065365492ca51ffec3'
AND (
token = 'nZbSdGqUrnO+pdnrEsRtYCzU54Fc9jXntNYN2N4uaHE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)