UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BEd0B4mzKqTUO2t/AkxLColOtbynJ9htPXajWkH3sLc='
WHERE
key_id = 'e830189271cee18d2c75064702a994c199a17305dbe240249b97d0910064fc31'
AND (
token = 'BEd0B4mzKqTUO2t/AkxLColOtbynJ9htPXajWkH3sLc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)