UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vhGxp0JTE1cktPEA/77YpWEr1A3GoeCh2+17/Oo1QFM='
WHERE
key_id = '47617e2af72b66387873b4efc0fd72befbf660da107b9e8fe437fa3d15a3a156'
AND (
token = 'vhGxp0JTE1cktPEA/77YpWEr1A3GoeCh2+17/Oo1QFM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)