UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0uiOpUlhU01vKKrA8Vf0sTFG671+vPtHb3jLei5e4Sw='
WHERE
key_id = '1f8bdc9023f594107a8bcab3ebf09bdc1a436d2252ddf5d56e6f802401de977a'
AND (
token = '0uiOpUlhU01vKKrA8Vf0sTFG671+vPtHb3jLei5e4Sw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)