UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4Yr8fAnOG0xqCPp3IPu1RBHcNdMm5Nx/rpFxuGudCUM='
WHERE
key_id = '8a38b4dc78d6cfb340733fc9a1e998f93ad3f79a9fe27a97c2ff2027ec743e38'
AND (
token = '4Yr8fAnOG0xqCPp3IPu1RBHcNdMm5Nx/rpFxuGudCUM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)