UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hAGhGsauyw1pk9tysj0ZqQQ6plrAYxVA93VBn0ky15Y='
WHERE
key_id = 'bf8d63d8db52e7b29ef813bfe2a90f2260de31a1f6ffd5e7c3f791cc74bcddf1'
AND (
token = 'hAGhGsauyw1pk9tysj0ZqQQ6plrAYxVA93VBn0ky15Y='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)