UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xo33WpbzPqRfbVXD9eaPCHxk8YBxD9nczBSCbHVa5Eo='
WHERE
key_id = '24107a78d4cbe18815782ad643a12911abaa94c104009d6538f397a096076193'
AND (
token = 'xo33WpbzPqRfbVXD9eaPCHxk8YBxD9nczBSCbHVa5Eo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)