UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'J2y9QnPqDOQ1SidtBmN1TvP5osW66ZdxT2iy2CIjQmI='
WHERE
key_id = '1dc33eaa139cda0db3363848ec70f1876f0624e8c6e4a98153b30d1060608df6'
AND (
token = 'J2y9QnPqDOQ1SidtBmN1TvP5osW66ZdxT2iy2CIjQmI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)