UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pucSL05ZFfUSXFbo5fst0kxZRdvPwBO7rg6MU7qbxDw='
WHERE
key_id = '863e938d1ebef172e63a16327c2b893c524eabd51ff6416d7d760179d89fc048'
AND (
token = 'pucSL05ZFfUSXFbo5fst0kxZRdvPwBO7rg6MU7qbxDw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)