UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'foDY2VRt+yt9zcY4pT3DJDs7CEysfWQFfb2c1n6PGWA='
WHERE
key_id = 'a123c286caeb6282b4c3fb97d37e1412e13facb1d5f2d09972e34ce1104ff860'
AND (
token = 'foDY2VRt+yt9zcY4pT3DJDs7CEysfWQFfb2c1n6PGWA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)