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