UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'A5bw18YKlfgurQe1PomGP5aCD9xrwCqjC+W1y34v8mM='
WHERE
key_id = 'b4b9cb80a5a4db79b08280518bb88f31b5525815bc52877488b5ab51b315c8d7'
AND (
token = 'A5bw18YKlfgurQe1PomGP5aCD9xrwCqjC+W1y34v8mM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)