UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6gNHRwHSyoBqjXxJ3pnuQkcH+xsUzaTa7kGQlJF/pT4='
WHERE
key_id = 'b9a46b671b2b2e43121a6ba1886f16fa092ff7fa58f7e4dcac7cd24e31cb7f60'
AND (
token = '6gNHRwHSyoBqjXxJ3pnuQkcH+xsUzaTa7kGQlJF/pT4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)