UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'prwEGaYOB0hV3dBnpnRvo/oJHVasw1pH3u7RVRe5is4='
WHERE
key_id = '552fd66ff7bb38c1324c2d976817abd5f331763e5e4f959c0c18f7d4eb77f2d8'
AND (
token = 'prwEGaYOB0hV3dBnpnRvo/oJHVasw1pH3u7RVRe5is4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)