UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZqL1KlGsMg9txoRMi3FsNhIkz4nEzhQnr669YCjTvSo='
WHERE
key_id = '8d60183e24699a948b182efecc78d2a25390977fe32ae1036a59ef5df989d3b1'
AND (
token = 'ZqL1KlGsMg9txoRMi3FsNhIkz4nEzhQnr669YCjTvSo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)