UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lMCnDaCcKa7+fBnLwAOE8nViK+QGSgBYmeo0XLmaBVk='
WHERE
key_id = '0e291a5bb5d5407630c9d08d9be9e0b8c3a73c89a7d12b8a7315b219ffe4e1b7'
AND (
token = 'lMCnDaCcKa7+fBnLwAOE8nViK+QGSgBYmeo0XLmaBVk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)