UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7dUlGj8C6j8prpOCWgbiRGJr/fTCGZ7YWEw6LkfVF/8='
WHERE
key_id = 'bcc7d8c39d4c86e3fb22a268c006f92c20b937490b74dcfa4b9015ccc673cd3e'
AND (
token = '7dUlGj8C6j8prpOCWgbiRGJr/fTCGZ7YWEw6LkfVF/8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)